{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Instructions","Humorous Monologues","HumorousMR","Dramatic","DramaticMR","Classical","ClassicalMR","Contemporary","ContemporaryMR","Pantomime","PantomimeMR","MusicalTheatre","MusicalTheatreMR","One-Acts","CostumeDesign","ScenicDesign","Sweepstakes","ScenicResults","CostumeResults"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[3,0,3,2],[4,0,4,2]]}
["Directions for Using the UHSAA SCORING SPREADSHEET"]
["for Region and State Theatre Meets:"]
[]
["If you have any questions, please email Giselle Gremmert at giselle.gremmert@canyonsdistrict.org"]
["If there is an emergency the day of your meet, feel free to call or text at 801-391-7864"]
["Before you start...",null,"In the Tab Room..."]
["Refresh your memory on the Policies and Guidelines of the Competition. Rules are changing every year. Make sure you have the most updated information! ",null,"If a school does not bring a full slate of pieces, you can leave boxes blank or enter a zero. Whichever makes sense for you."]
["Please make sure you are using the correct spreadsheet for your classification. Region and State Spreadsheets are different! 1A/2A is different from 3A-6A!",null,"As scores come in to the tabulation room, enter their respective rank (1-4 or 1-6) and score (0-75). The spreadsheet should do all of the math for you from there."]
["DO NOT, UNDER ANY CIRCUMSTANCES: delete a row or column, add a row or column. If you think there is a reason you need to do so, contact Giselle Gremmert first or you will likely ruin your whole spreadsheet. ",null,"Once you have all of your scores in and you need to determine which pieces will go to the final medals round, click on the medals round tab at the bottom of the spreadsheet. There is one for each event. All you have to do is click on the \"sort first by rank, then by score\" button, and the top 5-8 pieces on the table will be eligible for Medals' Round."]
["Each school should be assigned a letter code (ie. A, B, DD, etc…). You can type in which school belongs to which code on the Sweepstakes page of the score sheet. Do not try to add a school I or school O. The letters are skipped intentionally.",null,"Please note the drop-down menus for time violations. If a piece goes over or under time, you can just select the number of rounds that occurred in and the spreadsheet will do all the math for you. It will also strike out any piece that has a time violation in more than 1 round. This means it is ineligible to move on to State or go to Medals Round."]
["You can type in student names and piece titles next to their assigned number on each of the event pages.",null,"PLEASE NOTE: If a school has 4 entries in an event, on the State spreadsheet, the lowest score will automatically be dropped. You won’t have to do anything. This feature is not in the Region scoresheet, so make sure you’re using the correct one."]
["If you would like coaches to give you their entrant information in a convenient format for the spreadsheet, click on the  Slate Entry Form URL below. It has everything divided into the correct number of boxes so you can more easily copy and paste into this spreasheet. (File -->Make a copy). ",null,"Scores that turn the whole line yellow meet a point threshhold. At Region, that means the piece qualifies for State and receives a Superior Medal. At State, that means the piece receives a Superior Medal."]
["https://docs.google.com/spreadsheets/d/1KvhAQPQFbuyZ23tB98sun25-0YTyifYxrCT7RtfStYE/edit?usp=sharing",null,"IF A STUDENT MAKES MEDALS ROUND, they qualify for State/receive a Superior Medal EVEN IF their point total does not automatically qualify them. Make sure to check for any outlier students so you don't miss giving them a medal/sending them to State. Their line may not be yellow. "]

{"sheet":"Humorous Monologues","index":1,"n_rows":47,"n_cols":32,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Humorous Monologues",null,null,null,null,null,null,null,null,null,"Rank 1-4",null,null,null,null,null,null,null,null,null,null,null,null,"S","E","G","F","1violation","2violations","3violations"]
[null,null,null,null,null,null,null,null,null,null,"Round 1:",null,"Round 2:",null,"Round 3:",null,"-2 for each"]
[null,null,null,null,null,null,null,"Student Name",null,"Title of Piece","R1 rank","R1 score","R2 rank","R2 score","R3 rank","R3 score","Time Violations",null,"TOTAL SCORE",null,"TOTAL RANK",null,null,"TOTAL SCHOOL SWEEPS POINTS"]
["A-101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q4=\"1violation\",-7*1,IF(Q4=\"2violations\",-7*2,IF(Q4=\"3violations\",-7*3,IF(Q4=\"\",\"\"))))","v":""},{"$f":"SUM(L4,N4,P4,R4)","v":0},null,{"$f":"SUM(K4,M4,O4)","v":0},null,null,null,{"$f":"SUM(S4,S6,S5,S7)","v":0}]
["A-102",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q5=\"1violation\",-7*1,IF(Q5=\"2violations\",-7*2,IF(Q5=\"3violations\",-7*3,IF(Q5=\"\",\"\"))))","v":""},{"$f":"SUM(L5,N5,P5,R5)","v":0},null,{"$f":"SUM(K5,M5,O5)","v":0}]
["A-103",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q6=\"1violation\",-7*1,IF(Q6=\"2violations\",-7*2,IF(Q6=\"3violations\",-7*3,IF(Q6=\"\",\"\"))))","v":""},{"$f":"SUM(L6,N6,P6,R6)","v":0},null,{"$f":"SUM(K6,M6,O6)","v":0}]
["A-104",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L7,N7,P7,R7)","v":0},null,{"$f":"SUM(K7,M7,O7)","v":0}]
[]
["B-101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L9,N9,P9,R9)","v":0},null,{"$f":"SUM(K9,M9,O9)","v":0},null,null,null,{"$f":"SUM(S9,S11,S10,S12)","v":0}]
["B-102",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L10,N10,P10,R10)","v":0},null,{"$f":"SUM(K10,M10,O10)","v":0}]
["B-103",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L11,N11,P11,R11)","v":0},null,{"$f":"SUM(K11,M11,O11)","v":0}]
["B-104",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L12,N12,P12,R12)","v":0},null,{"$f":"SUM(K12,M12,O12)","v":0}]
[]
["C-101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L14,N14,P14,R14)","v":0},null,{"$f":"SUM(K14,M14,O14)","v":0},null,null,null,{"$f":"SUM(S14,S16,S15,S17)","v":0}]
["C-102",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L15,N15,P15,R15)","v":0},null,{"$f":"SUM(K15,M15,O15)","v":0}]
["C-103",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L16,N16,P16,R16)","v":0},null,{"$f":"SUM(K16,M16,O16)","v":0}]
["C-104",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L17,N17,P17,R17)","v":0},null,{"$f":"SUM(K17,M17,O17)","v":0}]
[]
["D-101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L19,N19,P19,R19)","v":0},null,{"$f":"SUM(K19,M19,O19)","v":0},null,null,null,{"$f":"SUM(S19,S21,S20,S22)","v":0}]
["D-102",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L20,N20,P20,R20)","v":0},null,{"$f":"SUM(K20,M20,O20)","v":0}]
["D-103",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L21,N21,P21,R21)","v":0},null,{"$f":"SUM(K21,M21,O21)","v":0}]
["D-104",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L22,N22,P22,R22)","v":0},null,{"$f":"SUM(K22,M22,O22)","v":0}]
[]
["E-101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L24,N24,P24,R24)","v":0},null,{"$f":"SUM(K24,M24,O24)","v":0},null,null,null,{"$f":"SUM(S24,S26,S25,S27)","v":0}]
["E-102",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L25,N25,P25,R25)","v":0},null,{"$f":"SUM(K25,M25,O25)","v":0}]
["E-103",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L26,N26,P26,R26)","v":0},null,{"$f":"SUM(K26,M26,O26)","v":0}]
["E-104",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L27,N27,P27,R27)","v":0},null,{"$f":"SUM(K27,M27,O27)","v":0}]
[]
["F-101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L29,N29,P29,R29)","v":0},null,{"$f":"SUM(K29,M29,O29)","v":0},null,null,null,{"$f":"SUM(S29,S31,S30,S32)","v":0}]
["F-102",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L30,N30,P30,R30)","v":0},null,{"$f":"SUM(K30,M30,O30)","v":0}]
["F-103",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L31,N31,P31,R31)","v":0},null,{"$f":"SUM(K31,M31,O31)","v":0}]
["F-104",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L32,N32,P32,R32)","v":0},null,{"$f":"SUM(K32,M32,O32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\\"]
["G-101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L34,N34,P34,R34)","v":0},null,{"$f":"SUM(K34,M34,O34)","v":0},null,null,null,{"$f":"SUM(S34,S36,S35,S37)","v":0},null,null,null,null,null,null,210]
["G-102",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L35,N35,P35,R35)","v":0},null,{"$f":"SUM(K35,M35,O35)","v":0}]
["G-103",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L36,N36,P36,R36)","v":0},null,{"$f":"SUM(K36,M36,O36)","v":0}]
["G-104",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L37,N37,P37,R37)","v":0},null,{"$f":"SUM(K37,M37,O37)","v":0}]
[]
["H-101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L39,N39,P39,R39)","v":0},null,{"$f":"SUM(K39,M39,O39)","v":0},null,null,null,{"$f":"SUM(S39,S41,S40,S42)","v":0}]
["H-102",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L40,N40,P40,R40)","v":0},null,{"$f":"SUM(K40,M40,O40)","v":0}]
["H-103",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L41,N41,P41,R41)","v":0},null,{"$f":"SUM(K41,M41,O41)","v":0}]
["H-104",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L42,N42,P42,R42)","v":0},null,{"$f":"SUM(K42,M42,O42)","v":0}]
[]
["J-101",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L44,N44,P44,R44)","v":0},null,{"$f":"SUM(K44,M44,O44)","v":0},null,null,null,{"$f":"SUM(S44,S46,S45,S47)","v":0}]
["J-102",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L45,N45,P45,R45)","v":0},null,{"$f":"SUM(K45,M45,O45)","v":0}]
["J-103",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L46,N46,P46,R46)","v":0},null,{"$f":"SUM(K46,M46,O46)","v":0}]
["J-104",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L47,N47,P47,R47)","v":0},null,{"$f":"SUM(K47,M47,O47)","v":0}]

{"sheet":"HumorousMR","index":2,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Humorous",null,null,null,"Finals Medals Round Scores"]
["ID","Rank","Score","LeaveBlank","MR 1 Rank","MR 1 Score","MR2 Rank","MR 2 Score","MR3 Rank","MR 3 Score","Total MR Rank","Total MR Score"]
[{"$f":"'Humorous Monologues'!A4","v":"A-101"},{"$f":"'Humorous Monologues'!U4","v":0},{"$f":"'Humorous Monologues'!S4","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,{"$f":"SUM(E3,G3,I3)","v":0},{"$f":"SUM(F3,H3,J3)","v":0}]
[{"$f":"'Humorous Monologues'!A5","v":"A-102"},{"$f":"'Humorous Monologues'!U5","v":0},{"$f":"'Humorous Monologues'!S5","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A6","v":"A-103"},{"$f":"'Humorous Monologues'!U6","v":0},{"$f":"'Humorous Monologues'!S6","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A7","v":"A-104"},{"$f":"'Humorous Monologues'!U7","v":0},{"$f":"'Humorous Monologues'!S7","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A9","v":"B-101"},{"$f":"'Humorous Monologues'!U9","v":0},{"$f":"'Humorous Monologues'!S9","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A10","v":"B-102"},{"$f":"'Humorous Monologues'!U10","v":0},{"$f":"'Humorous Monologues'!S10","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A11","v":"B-103"},{"$f":"'Humorous Monologues'!U11","v":0},{"$f":"'Humorous Monologues'!S11","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A12","v":"B-104"},{"$f":"'Humorous Monologues'!U12","v":0},{"$f":"'Humorous Monologues'!S12","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A14","v":"C-101"},{"$f":"'Humorous Monologues'!U14","v":0},{"$f":"'Humorous Monologues'!S14","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A15","v":"C-102"},{"$f":"'Humorous Monologues'!U15","v":0},{"$f":"'Humorous Monologues'!S15","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A16","v":"C-103"},{"$f":"'Humorous Monologues'!U16","v":0},{"$f":"'Humorous Monologues'!S16","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A17","v":"C-104"},{"$f":"'Humorous Monologues'!U17","v":0},{"$f":"'Humorous Monologues'!S17","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A19","v":"D-101"},{"$f":"'Humorous Monologues'!U19","v":0},{"$f":"'Humorous Monologues'!S19","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A20","v":"D-102"},{"$f":"'Humorous Monologues'!U20","v":0},{"$f":"'Humorous Monologues'!S20","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A21","v":"D-103"},{"$f":"'Humorous Monologues'!U21","v":0},{"$f":"'Humorous Monologues'!S21","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A22","v":"D-104"},{"$f":"'Humorous Monologues'!U22","v":0},{"$f":"'Humorous Monologues'!S22","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A24","v":"E-101"},{"$f":"'Humorous Monologues'!U24","v":0},{"$f":"'Humorous Monologues'!S24","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A25","v":"E-102"},{"$f":"'Humorous Monologues'!U25","v":0},{"$f":"'Humorous Monologues'!S25","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A26","v":"E-103"},{"$f":"'Humorous Monologues'!U26","v":0},{"$f":"'Humorous Monologues'!S26","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A27","v":"E-104"},{"$f":"'Humorous Monologues'!U27","v":0},{"$f":"'Humorous Monologues'!S27","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A29","v":"F-101"},{"$f":"'Humorous Monologues'!U29","v":0},{"$f":"'Humorous Monologues'!S29","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A30","v":"F-102"},{"$f":"'Humorous Monologues'!U30","v":0},{"$f":"'Humorous Monologues'!S30","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A31","v":"F-103"},{"$f":"'Humorous Monologues'!U31","v":0},{"$f":"'Humorous Monologues'!S31","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A32","v":"F-104"},{"$f":"'Humorous Monologues'!U32","v":0},{"$f":"'Humorous Monologues'!S32","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A34","v":"G-101"},{"$f":"'Humorous Monologues'!U34","v":0},{"$f":"'Humorous Monologues'!S34","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A35","v":"G-102"},{"$f":"'Humorous Monologues'!U35","v":0},{"$f":"'Humorous Monologues'!S35","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A36","v":"G-103"},{"$f":"'Humorous Monologues'!U36","v":0},{"$f":"'Humorous Monologues'!S36","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A37","v":"G-104"},{"$f":"'Humorous Monologues'!U37","v":0},{"$f":"'Humorous Monologues'!S37","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A39","v":"H-101"},{"$f":"'Humorous Monologues'!U39","v":0},{"$f":"'Humorous Monologues'!S39","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A40","v":"H-102"},{"$f":"'Humorous Monologues'!U40","v":0},{"$f":"'Humorous Monologues'!S40","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A41","v":"H-103"},{"$f":"'Humorous Monologues'!U41","v":0},{"$f":"'Humorous Monologues'!S41","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A42","v":"H-104"},{"$f":"'Humorous Monologues'!U42","v":0},{"$f":"'Humorous Monologues'!S42","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A44","v":"J-101"},{"$f":"'Humorous Monologues'!U44","v":0},{"$f":"'Humorous Monologues'!S44","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A45","v":"J-102"},{"$f":"'Humorous Monologues'!U45","v":0},{"$f":"'Humorous Monologues'!S45","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A46","v":"J-103"},{"$f":"'Humorous Monologues'!U46","v":0},{"$f":"'Humorous Monologues'!S46","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"'Humorous Monologues'!A47","v":"J-104"},{"$f":"'Humorous Monologues'!U47","v":0},{"$f":"'Humorous Monologues'!S47","v":0},{"$f":"IF((Table7[[#This Row],[Rank]]+Table7[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]

{"sheet":"Dramatic","index":3,"n_rows":47,"n_cols":30,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Dramatic Monologues",null,null,null,null,null,null,null,null,null,"Rank 1-4",null,null,null,null,null,null,null,null,null,null,null,null,"S","E","G","F","1violation","2violations","3violations"]
[null,null,null,null,null,null,null,null,null,null,"Round 1:",null,"Round 2:",null,"Round 3:",null,"-2 for each"]
[null,null,null,null,null,null,null,"Student Name",null,"Title of Piece","R1 rank","R1 score","R2 rank","R2 score","R3 rank","R3 score","Time Violations",null,"TOTAL SCORE",null,"TOTAL RANK",null,null,"TOTAL SCHOOL SWEEPS POINTS"]
["A-201",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q4=\"1violation\",-7*1,IF(Q4=\"2violations\",-7*2,IF(Q4=\"3violations\",-7*3,IF(Q4=\"\",\"\"))))","v":""},{"$f":"SUM(L4,N4,P4,R4)","v":0},null,{"$f":"SUM(K4,M4,O4)","v":0},null,null,null,{"$f":"SUM(S4,S6,S5,S7)","v":0}]
["A-202",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q5=\"1violation\",-7*1,IF(Q5=\"2violations\",-7*2,IF(Q5=\"3violations\",-7*3,IF(Q5=\"\",\"\"))))","v":""},{"$f":"SUM(L5,N5,P5,R5)","v":0},null,{"$f":"SUM(K5,M5,O5)","v":0}]
["A-203",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L6,N6,P6,R6)","v":0},null,{"$f":"SUM(K6,M6,O6)","v":0}]
["A-204",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L7,N7,P7,R7)","v":0},null,{"$f":"SUM(K7,M7,O7)","v":0}]
[]
["B-201",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L9,N9,P9,R9)","v":0},null,{"$f":"SUM(K9,M9,O9)","v":0},null,null,null,{"$f":"SUM(S9,S11,S10,S12)","v":0}]
["B-202",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L10,N10,P10,R10)","v":0},null,{"$f":"SUM(K10,M10,O10)","v":0}]
["B-203",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L11,N11,P11,R11)","v":0},null,{"$f":"SUM(K11,M11,O11)","v":0}]
["B-204",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L12,N12,P12,R12)","v":0},null,{"$f":"SUM(K12,M12,O12)","v":0}]
[]
["C-201",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L14,N14,P14,R14)","v":0},null,{"$f":"SUM(K14,M14,O14)","v":0},null,null,null,{"$f":"SUM(S14,S16,S15,S17)","v":0}]
["C-202",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L15,N15,P15,R15)","v":0},null,{"$f":"SUM(K15,M15,O15)","v":0}]
["C-203",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L16,N16,P16,R16)","v":0},null,{"$f":"SUM(K16,M16,O16)","v":0}]
["C-204",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L17,N17,P17,R17)","v":0},null,{"$f":"SUM(K17,M17,O17)","v":0}]
[]
["D-201",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L19,N19,P19,R19)","v":0},null,{"$f":"SUM(K19,M19,O19)","v":0},null,null,null,{"$f":"SUM(S19,S21,S20,S22)","v":0}]
["D-202",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L20,N20,P20,R20)","v":0},null,{"$f":"SUM(K20,M20,O20)","v":0}]
["D-203",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L21,N21,P21,R21)","v":0},null,{"$f":"SUM(K21,M21,O21)","v":0}]
["D-204",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L22,N22,P22,R22)","v":0},null,{"$f":"SUM(K22,M22,O22)","v":0}]
[]
["E-201",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L24,N24,P24,R24)","v":0},null,{"$f":"SUM(K24,M24,O24)","v":0},null,null,null,{"$f":"SUM(S24,S26,S25,S27)","v":0}]
["E-202",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L25,N25,P25,R25)","v":0},null,{"$f":"SUM(K25,M25,O25)","v":0}]
["E-203",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L26,N26,P26,R26)","v":0},null,{"$f":"SUM(K26,M26,O26)","v":0}]
["E-204",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L27,N27,P27,R27)","v":0},null,{"$f":"SUM(K27,M27,O27)","v":0}]
[]
["F-201",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L29,N29,P29,R29)","v":0},null,{"$f":"SUM(K29,M29,O29)","v":0},null,null,null,{"$f":"SUM(S29,S31,S30,S32)","v":0}]
["F-202",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L30,N30,P30,R30)","v":0},null,{"$f":"SUM(K30,M30,O30)","v":0}]
["F-203",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L31,N31,P31,R31)","v":0},null,{"$f":"SUM(K31,M31,O31)","v":0}]
["F-204",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L32,N32,P32,R32)","v":0},null,{"$f":"SUM(K32,M32,O32)","v":0}]
[]
["G-201",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L34,N34,P34,R34)","v":0},null,{"$f":"SUM(K34,M34,O34)","v":0},null,null,null,{"$f":"SUM(S34,S36,S35,S37)","v":0}]
["G-202",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L35,N35,P35,R35)","v":0},null,{"$f":"SUM(K35,M35,O35)","v":0}]
["G-203",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L36,N36,P36,R36)","v":0},null,{"$f":"SUM(K36,M36,O36)","v":0}]
["G-204",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L37,N37,P37,R37)","v":0},null,{"$f":"SUM(K37,M37,O37)","v":0}]
[]
["H-201",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L39,N39,P39,R39)","v":0},null,{"$f":"SUM(K39,M39,O39)","v":0},null,null,null,{"$f":"SUM(S39,S41,S40,S42)","v":0}]
["H-202",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L40,N40,P40,R40)","v":0},null,{"$f":"SUM(K40,M40,O40)","v":0}]
["H-203",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L41,N41,P41,R41)","v":0},null,{"$f":"SUM(K41,M41,O41)","v":0}]
["H-204",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L42,N42,P42,R42)","v":0},null,{"$f":"SUM(K42,M42,O42)","v":0}]
[]
["J-201",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L44,N44,P44,R44)","v":0},null,{"$f":"SUM(K44,M44,O44)","v":0},null,null,null,{"$f":"SUM(S44,S46,S45,S47)","v":0}]
["J-202",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L45,N45,P45,R45)","v":0},null,{"$f":"SUM(K45,M45,O45)","v":0}]
["J-203",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L46,N46,P46,R46)","v":0},null,{"$f":"SUM(K46,M46,O46)","v":0}]
["J-204",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L47,N47,P47,R47)","v":0},null,{"$f":"SUM(K47,M47,O47)","v":0}]

{"sheet":"DramaticMR","index":4,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Dramatic",null,null,null,"Finals Medals Round Scores"]
["ID","Rank","Score","LeaveBlank","MR 1 Rank","MR 1 Score","MR2 Rank","MR 2 Score","MR3 Rank","MR 3 Score","Total MR Rank","Total MR Score"]
[{"$f":"Dramatic!A4","v":"A-201"},{"$f":"Dramatic!U4","v":0},{"$f":"Dramatic!S4","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,{"$f":"SUM(E3,G3,I3)","v":0},{"$f":"SUM(F3,H3,J3)","v":0}]
[{"$f":"Dramatic!A5","v":"A-202"},{"$f":"Dramatic!U5","v":0},{"$f":"Dramatic!S5","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A6","v":"A-203"},{"$f":"Dramatic!U6","v":0},{"$f":"Dramatic!S6","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A7","v":"A-204"},{"$f":"Dramatic!U7","v":0},{"$f":"Dramatic!S7","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A9","v":"B-201"},{"$f":"Dramatic!U9","v":0},{"$f":"Dramatic!S9","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A10","v":"B-202"},{"$f":"Dramatic!U10","v":0},{"$f":"Dramatic!S10","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A11","v":"B-203"},{"$f":"Dramatic!U11","v":0},{"$f":"Dramatic!S11","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A12","v":"B-204"},{"$f":"Dramatic!U12","v":0},{"$f":"Dramatic!S12","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A14","v":"C-201"},{"$f":"Dramatic!U14","v":0},{"$f":"Dramatic!S14","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A15","v":"C-202"},{"$f":"Dramatic!U15","v":0},{"$f":"Dramatic!S15","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A16","v":"C-203"},{"$f":"Dramatic!U16","v":0},{"$f":"Dramatic!S16","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A17","v":"C-204"},{"$f":"Dramatic!U17","v":0},{"$f":"Dramatic!S17","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A19","v":"D-201"},{"$f":"Dramatic!U19","v":0},{"$f":"Dramatic!S19","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A20","v":"D-202"},{"$f":"Dramatic!U20","v":0},{"$f":"Dramatic!S20","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A21","v":"D-203"},{"$f":"Dramatic!U21","v":0},{"$f":"Dramatic!S21","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A22","v":"D-204"},{"$f":"Dramatic!U22","v":0},{"$f":"Dramatic!S22","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A24","v":"E-201"},{"$f":"Dramatic!U24","v":0},{"$f":"Dramatic!S24","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A25","v":"E-202"},{"$f":"Dramatic!U25","v":0},{"$f":"Dramatic!S25","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A26","v":"E-203"},{"$f":"Dramatic!U26","v":0},{"$f":"Dramatic!S26","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A27","v":"E-204"},{"$f":"Dramatic!U27","v":0},{"$f":"Dramatic!S27","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A29","v":"F-201"},{"$f":"Dramatic!U29","v":0},{"$f":"Dramatic!S29","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A30","v":"F-202"},{"$f":"Dramatic!U30","v":0},{"$f":"Dramatic!S30","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A31","v":"F-203"},{"$f":"Dramatic!U31","v":0},{"$f":"Dramatic!S31","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A32","v":"F-204"},{"$f":"Dramatic!U32","v":0},{"$f":"Dramatic!S32","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A34","v":"G-201"},{"$f":"Dramatic!U34","v":0},{"$f":"Dramatic!S34","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A35","v":"G-202"},{"$f":"Dramatic!U35","v":0},{"$f":"Dramatic!S35","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A36","v":"G-203"},{"$f":"Dramatic!U36","v":0},{"$f":"Dramatic!S36","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A37","v":"G-204"},{"$f":"Dramatic!U37","v":0},{"$f":"Dramatic!S37","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A39","v":"H-201"},{"$f":"Dramatic!U39","v":0},{"$f":"Dramatic!S39","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A40","v":"H-202"},{"$f":"Dramatic!U40","v":0},{"$f":"Dramatic!S40","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A41","v":"H-203"},{"$f":"Dramatic!U41","v":0},{"$f":"Dramatic!S41","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A42","v":"H-204"},{"$f":"Dramatic!U42","v":0},{"$f":"Dramatic!S42","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A44","v":"J-201"},{"$f":"Dramatic!U44","v":0},{"$f":"Dramatic!S44","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A45","v":"J-202"},{"$f":"Dramatic!U45","v":0},{"$f":"Dramatic!S45","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A46","v":"J-203"},{"$f":"Dramatic!U46","v":0},{"$f":"Dramatic!S46","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Dramatic!A47","v":"J-204"},{"$f":"Dramatic!U47","v":0},{"$f":"Dramatic!S47","v":0},{"$f":"IF((Table710[[#This Row],[Rank]]+Table710[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]

{"sheet":"Classical","index":5,"n_rows":47,"n_cols":30,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Classical Scenes",null,null,null,null,null,null,null,null,null,"Rank 1-4",null,null,null,null,null,null,null,null,null,null,null,null,"S","E","G","F","1violation","2violations","3violations"]
[null,null,null,null,null,null,null,null,null,null,"Round 1:",null,"Round 2:",null,"Round 3:",null,"-2 for each"]
[null,null,null,"Student Name",null,"Student Name",null,"Student Name",null,"Title of Piece","R1 rank","R1 score","R2 rank","R2 score","R3 rank","R3 score","Time Violations",null,"TOTAL SCORE",null,"TOTAL RANK",null,null,"TOTAL SCHOOL SWEEPS POINTS"]
["A-301",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q4=\"1violation\",-7*1,IF(Q4=\"2violations\",-7*2,IF(Q4=\"3violations\",-7*3,IF(Q4=\"\",\"\"))))","v":""},{"$f":"SUM(L4,N4,P4,R4)","v":0},null,{"$f":"SUM(K4,M4,O4)","v":0},null,null,null,{"$f":"SUM(S4,S6,S5,S7)","v":0}]
["A-302",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q5=\"1violation\",-7*1,IF(Q5=\"2violations\",-7*2,IF(Q5=\"3violations\",-7*3,IF(Q5=\"\",\"\"))))","v":""},{"$f":"SUM(L5,N5,P5,R5)","v":0},null,{"$f":"SUM(K5,M5,O5)","v":0}]
["A-303",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L6,N6,P6,R6)","v":0},null,{"$f":"SUM(K6,M6,O6)","v":0}]
["A-304",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L7,N7,P7,R7)","v":0},null,{"$f":"SUM(K7,M7,O7)","v":0}]
[]
["B-301",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L9,N9,P9,R9)","v":0},null,{"$f":"SUM(K9,M9,O9)","v":0},null,null,null,{"$f":"SUM(S9,S11,S10,S12)","v":0}]
["B-302",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L10,N10,P10,R10)","v":0},null,{"$f":"SUM(K10,M10,O10)","v":0}]
["B-303",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L11,N11,P11,R11)","v":0},null,{"$f":"SUM(K11,M11,O11)","v":0}]
["B-304",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L12,N12,P12,R12)","v":0},null,{"$f":"SUM(K12,M12,O12)","v":0}]
[]
["C-301",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L14,N14,P14,R14)","v":0},null,{"$f":"SUM(K14,M14,O14)","v":0},null,null,null,{"$f":"SUM(S14,S16,S15,S17)","v":0}]
["C-302",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L15,N15,P15,R15)","v":0},null,{"$f":"SUM(K15,M15,O15)","v":0}]
["C-303",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L16,N16,P16,R16)","v":0},null,{"$f":"SUM(K16,M16,O16)","v":0}]
["C-304",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L17,N17,P17,R17)","v":0},null,{"$f":"SUM(K17,M17,O17)","v":0}]
[]
["D-301",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L19,N19,P19,R19)","v":0},null,{"$f":"SUM(K19,M19,O19)","v":0},null,null,null,{"$f":"SUM(S19,S21,S20,S22)","v":0}]
["D-302",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L20,N20,P20,R20)","v":0},null,{"$f":"SUM(K20,M20,O20)","v":0}]
["D-303",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L21,N21,P21,R21)","v":0},null,{"$f":"SUM(K21,M21,O21)","v":0}]
["D-304",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L22,N22,P22,R22)","v":0},null,{"$f":"SUM(K22,M22,O22)","v":0}]
[]
["E-301",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L24,N24,P24,R24)","v":0},null,{"$f":"SUM(K24,M24,O24)","v":0},null,null,null,{"$f":"SUM(S24,S26,S25,S27)","v":0}]
["E-302",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L25,N25,P25,R25)","v":0},null,{"$f":"SUM(K25,M25,O25)","v":0}]
["E-303",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L26,N26,P26,R26)","v":0},null,{"$f":"SUM(K26,M26,O26)","v":0}]
["E-304",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L27,N27,P27,R27)","v":0},null,{"$f":"SUM(K27,M27,O27)","v":0}]
[]
["F-301",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L29,N29,P29,R29)","v":0},null,{"$f":"SUM(K29,M29,O29)","v":0},null,null,null,{"$f":"SUM(S29,S31,S30,S32)","v":0}]
["F-302",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L30,N30,P30,R30)","v":0},null,{"$f":"SUM(K30,M30,O30)","v":0}]
["F-303",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L31,N31,P31,R31)","v":0},null,{"$f":"SUM(K31,M31,O31)","v":0}]
["F-304",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L32,N32,P32,R32)","v":0},null,{"$f":"SUM(K32,M32,O32)","v":0}]
[]
["G-301",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L34,N34,P34,R34)","v":0},null,{"$f":"SUM(K34,M34,O34)","v":0},null,null,null,{"$f":"SUM(S34,S36,S35,S37)","v":0}]
["G-302",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L35,N35,P35,R35)","v":0},null,{"$f":"SUM(K35,M35,O35)","v":0}]
["G-303",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L36,N36,P36,R36)","v":0},null,{"$f":"SUM(K36,M36,O36)","v":0}]
["G-304",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L37,N37,P37,R37)","v":0},null,{"$f":"SUM(K37,M37,O37)","v":0}]
[]
["H-301",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L39,N39,P39,R39)","v":0},null,{"$f":"SUM(K39,M39,O39)","v":0},null,null,null,{"$f":"SUM(S39,S41,S40,S42)","v":0}]
["H-302",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L40,N40,P40,R40)","v":0},null,{"$f":"SUM(K40,M40,O40)","v":0}]
["H-303",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L41,N41,P41,R41)","v":0},null,{"$f":"SUM(K41,M41,O41)","v":0}]
["H-304",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L42,N42,P42,R42)","v":0},null,{"$f":"SUM(K42,M42,O42)","v":0}]
[]
["J-301",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L44,N44,P44,R44)","v":0},null,{"$f":"SUM(K44,M44,O44)","v":0},null,null,null,{"$f":"SUM(S44,S46,S45,S47)","v":0}]
["J-302",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L45,N45,P45,R45)","v":0},null,{"$f":"SUM(K45,M45,O45)","v":0}]
["J-303",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L46,N46,P46,R46)","v":0},null,{"$f":"SUM(K46,M46,O46)","v":0}]
["J-304",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L47,N47,P47,R47)","v":0},null,{"$f":"SUM(K47,M47,O47)","v":0}]

{"sheet":"ClassicalMR","index":6,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Classical",null,null,null,"Finals Medals Round Scores"]
["ID","Rank","Score","LeaveBlank","MR 1 Rank","MR 1 Score","MR2 Rank","MR 2 Score","MR3 Rank","MR 3 Score","Total MR Rank","Total MR Score"]
[{"$f":"Classical!A4","v":"A-301"},{"$f":"Classical!U4","v":0},{"$f":"Classical!S4","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,{"$f":"SUM(E3,G3,I3)","v":0},{"$f":"SUM(F3,H3,J3)","v":0}]
[{"$f":"Classical!A5","v":"A-302"},{"$f":"Classical!U5","v":0},{"$f":"Classical!S5","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A6","v":"A-303"},{"$f":"Classical!U6","v":0},{"$f":"Classical!S6","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A7","v":"A-304"},{"$f":"Classical!U7","v":0},{"$f":"Classical!S7","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A9","v":"B-301"},{"$f":"Classical!U9","v":0},{"$f":"Classical!S9","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A10","v":"B-302"},{"$f":"Classical!U10","v":0},{"$f":"Classical!S10","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A11","v":"B-303"},{"$f":"Classical!U11","v":0},{"$f":"Classical!S11","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A12","v":"B-304"},{"$f":"Classical!U12","v":0},{"$f":"Classical!S12","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A14","v":"C-301"},{"$f":"Classical!U14","v":0},{"$f":"Classical!S14","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A15","v":"C-302"},{"$f":"Classical!U15","v":0},{"$f":"Classical!S15","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A16","v":"C-303"},{"$f":"Classical!U16","v":0},{"$f":"Classical!S16","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A17","v":"C-304"},{"$f":"Classical!U17","v":0},{"$f":"Classical!S17","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A19","v":"D-301"},{"$f":"Classical!U19","v":0},{"$f":"Classical!S19","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A20","v":"D-302"},{"$f":"Classical!U20","v":0},{"$f":"Classical!S20","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A21","v":"D-303"},{"$f":"Classical!U21","v":0},{"$f":"Classical!S21","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A22","v":"D-304"},{"$f":"Classical!U22","v":0},{"$f":"Classical!S22","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A24","v":"E-301"},{"$f":"Classical!U24","v":0},{"$f":"Classical!S24","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A25","v":"E-302"},{"$f":"Classical!U25","v":0},{"$f":"Classical!S25","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A26","v":"E-303"},{"$f":"Classical!U26","v":0},{"$f":"Classical!S26","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A27","v":"E-304"},{"$f":"Classical!U27","v":0},{"$f":"Classical!S27","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A29","v":"F-301"},{"$f":"Classical!U29","v":0},{"$f":"Classical!S29","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A30","v":"F-302"},{"$f":"Classical!U30","v":0},{"$f":"Classical!S30","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A31","v":"F-303"},{"$f":"Classical!U31","v":0},{"$f":"Classical!S31","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A32","v":"F-304"},{"$f":"Classical!U32","v":0},{"$f":"Classical!S32","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A34","v":"G-301"},{"$f":"Classical!U34","v":0},{"$f":"Classical!S34","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A35","v":"G-302"},{"$f":"Classical!U35","v":0},{"$f":"Classical!S35","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A36","v":"G-303"},{"$f":"Classical!U36","v":0},{"$f":"Classical!S36","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A37","v":"G-304"},{"$f":"Classical!U37","v":0},{"$f":"Classical!S37","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A39","v":"H-301"},{"$f":"Classical!U39","v":0},{"$f":"Classical!S39","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A40","v":"H-302"},{"$f":"Classical!U40","v":0},{"$f":"Classical!S40","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A41","v":"H-303"},{"$f":"Classical!U41","v":0},{"$f":"Classical!S41","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A42","v":"H-304"},{"$f":"Classical!U42","v":0},{"$f":"Classical!S42","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A44","v":"J-301"},{"$f":"Classical!U44","v":0},{"$f":"Classical!S44","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A45","v":"J-302"},{"$f":"Classical!U45","v":0},{"$f":"Classical!S45","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A46","v":"J-303"},{"$f":"Classical!U46","v":0},{"$f":"Classical!S46","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Classical!A47","v":"J-304"},{"$f":"Classical!U47","v":0},{"$f":"Classical!S47","v":0},{"$f":"IF((Table71012[[#This Row],[Rank]]+Table71012[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]

{"sheet":"Contemporary","index":7,"n_rows":47,"n_cols":30,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Contemporary Scenes",null,null,null,null,null,null,null,null,null,"Rank 1-4",null,null,null,null,null,null,null,null,null,null,null,null,"S","E","G","F","1violation","2violations","3violations"]
[null,null,null,null,null,null,null,null,null,null,"Round 1:",null,"Round 2:",null,"Round 3:",null,"-2 for each"]
[null,null,null,"Student Name",null,"Student Name",null,"Student Name",null,"Title of Piece","R1 rank","R1 score","R2 rank","R2 score","R3 rank","R3 score","Time Violations",null,"TOTAL SCORE",null,"TOTAL RANK",null,null,"TOTAL SCHOOL SWEEPS POINTS"]
["A-401",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q4=\"1violation\",-7*1,IF(Q4=\"2violations\",-7*2,IF(Q4=\"3violations\",-7*3,IF(Q4=\"\",\"\"))))","v":""},{"$f":"SUM(L4,N4,P4,R4)","v":0},null,{"$f":"SUM(K4,M4,O4)","v":0},null,null,null,{"$f":"SUM(S4,S6,S5,S7)","v":0}]
["A-402",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q5=\"1violation\",-7*1,IF(Q5=\"2violations\",-7*2,IF(Q5=\"3violations\",-7*3,IF(Q5=\"\",\"\"))))","v":""},{"$f":"SUM(L5,N5,P5,R5)","v":0},null,{"$f":"SUM(K5,M5,O5)","v":0}]
["A-403",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L6,N6,P6,R6)","v":0},null,{"$f":"SUM(K6,M6,O6)","v":0}]
["A-404",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L7,N7,P7,R7)","v":0},null,{"$f":"SUM(K7,M7,O7)","v":0}]
[]
["B-401",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L9,N9,P9,R9)","v":0},null,{"$f":"SUM(K9,M9,O9)","v":0},null,null,null,{"$f":"SUM(S9,S11,S10,S12)","v":0}]
["B-402",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L10,N10,P10,R10)","v":0},null,{"$f":"SUM(K10,M10,O10)","v":0}]
["B-403",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L11,N11,P11,R11)","v":0},null,{"$f":"SUM(K11,M11,O11)","v":0}]
["B-404",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L12,N12,P12,R12)","v":0},null,{"$f":"SUM(K12,M12,O12)","v":0}]
[]
["C-401",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L14,N14,P14,R14)","v":0},null,{"$f":"SUM(K14,M14,O14)","v":0},null,null,null,{"$f":"SUM(S14,S16,S15,S17)","v":0}]
["C-402",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L15,N15,P15,R15)","v":0},null,{"$f":"SUM(K15,M15,O15)","v":0}]
["C-403",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L16,N16,P16,R16)","v":0},null,{"$f":"SUM(K16,M16,O16)","v":0}]
["C-404",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L17,N17,P17,R17)","v":0},null,{"$f":"SUM(K17,M17,O17)","v":0}]
[]
["D-401",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L19,N19,P19,R19)","v":0},null,{"$f":"SUM(K19,M19,O19)","v":0},null,null,null,{"$f":"SUM(S19,S21,S20,S22)","v":0}]
["D-402",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L20,N20,P20,R20)","v":0},null,{"$f":"SUM(K20,M20,O20)","v":0}]
["D-403",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L21,N21,P21,R21)","v":0},null,{"$f":"SUM(K21,M21,O21)","v":0}]
["D-404",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L22,N22,P22,R22)","v":0},null,{"$f":"SUM(K22,M22,O22)","v":0}]
[]
["E-401",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L24,N24,P24,R24)","v":0},null,{"$f":"SUM(K24,M24,O24)","v":0},null,null,null,{"$f":"SUM(S24,S26,S25,S27)","v":0}]
["E-402",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L25,N25,P25,R25)","v":0},null,{"$f":"SUM(K25,M25,O25)","v":0}]
["E-403",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L26,N26,P26,R26)","v":0},null,{"$f":"SUM(K26,M26,O26)","v":0}]
["E-404",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L27,N27,P27,R27)","v":0},null,{"$f":"SUM(K27,M27,O27)","v":0}]
[]
["F-401",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L29,N29,P29,R29)","v":0},null,{"$f":"SUM(K29,M29,O29)","v":0},null,null,null,{"$f":"SUM(S29,S31,S30,S32)","v":0}]
["F-402",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L30,N30,P30,R30)","v":0},null,{"$f":"SUM(K30,M30,O30)","v":0}]
["F-403",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L31,N31,P31,R31)","v":0},null,{"$f":"SUM(K31,M31,O31)","v":0}]
["F-404",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L32,N32,P32,R32)","v":0},null,{"$f":"SUM(K32,M32,O32)","v":0}]
[]
["G-401",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L34,N34,P34,R34)","v":0},null,{"$f":"SUM(K34,M34,O34)","v":0},null,null,null,{"$f":"SUM(S34,S36,S35,S37)","v":0}]
["G-402",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L35,N35,P35,R35)","v":0},null,{"$f":"SUM(K35,M35,O35)","v":0}]
["G-403",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L36,N36,P36,R36)","v":0},null,{"$f":"SUM(K36,M36,O36)","v":0}]
["G-404",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L37,N37,P37,R37)","v":0},null,{"$f":"SUM(K37,M37,O37)","v":0}]
[]
["H-401",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L39,N39,P39,R39)","v":0},null,{"$f":"SUM(K39,M39,O39)","v":0},null,null,null,{"$f":"SUM(S39,S41,S40,S42)","v":0}]
["H-402",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L40,N40,P40,R40)","v":0},null,{"$f":"SUM(K40,M40,O40)","v":0}]
["H-403",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L41,N41,P41,R41)","v":0},null,{"$f":"SUM(K41,M41,O41)","v":0}]
["H-404",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L42,N42,P42,R42)","v":0},null,{"$f":"SUM(K42,M42,O42)","v":0}]
[]
["J-401",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L44,N44,P44,R44)","v":0},null,{"$f":"SUM(K44,M44,O44)","v":0},null,null,null,{"$f":"SUM(S44,S46,S45,S47)","v":0}]
["J-402",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L45,N45,P45,R45)","v":0},null,{"$f":"SUM(K45,M45,O45)","v":0}]
["J-403",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L46,N46,P46,R46)","v":0},null,{"$f":"SUM(K46,M46,O46)","v":0}]
["J-404",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L47,N47,P47,R47)","v":0},null,{"$f":"SUM(K47,M47,O47)","v":0}]

{"sheet":"ContemporaryMR","index":8,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Contemporary ",0,null,null,"Finals Medals Round Scores"]
["ID","Rank","Score","LeaveBlank","MR 1 Rank","MR 1 Score","MR2 Rank","MR 2 Score","MR3 Rank","MR 3 Score","Total MR Rank","Total MR Score"]
[{"$f":"Contemporary!A4","v":"A-401"},{"$f":"Contemporary!U4","v":0},{"$f":"Contemporary!S4","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,{"$f":"SUM(E3,G3,I3)","v":0},{"$f":"SUM(F3,H3,J3)","v":0}]
[{"$f":"Contemporary!A5","v":"A-402"},{"$f":"Contemporary!U5","v":0},{"$f":"Contemporary!S5","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A6","v":"A-403"},{"$f":"Contemporary!U6","v":0},{"$f":"Contemporary!S6","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A7","v":"A-404"},{"$f":"Contemporary!U7","v":0},{"$f":"Contemporary!S7","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A9","v":"B-401"},{"$f":"Contemporary!U9","v":0},{"$f":"Contemporary!S9","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A10","v":"B-402"},{"$f":"Contemporary!U10","v":0},{"$f":"Contemporary!S10","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A11","v":"B-403"},{"$f":"Contemporary!U11","v":0},{"$f":"Contemporary!S11","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A12","v":"B-404"},{"$f":"Contemporary!U12","v":0},{"$f":"Contemporary!S12","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A14","v":"C-401"},{"$f":"Contemporary!U14","v":0},{"$f":"Contemporary!S14","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A15","v":"C-402"},{"$f":"Contemporary!U15","v":0},{"$f":"Contemporary!S15","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A16","v":"C-403"},{"$f":"Contemporary!U16","v":0},{"$f":"Contemporary!S16","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A17","v":"C-404"},{"$f":"Contemporary!U17","v":0},{"$f":"Contemporary!S17","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A19","v":"D-401"},{"$f":"Contemporary!U19","v":0},{"$f":"Contemporary!S19","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A20","v":"D-402"},{"$f":"Contemporary!U20","v":0},{"$f":"Contemporary!S20","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A21","v":"D-403"},{"$f":"Contemporary!U21","v":0},{"$f":"Contemporary!S21","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A22","v":"D-404"},{"$f":"Contemporary!U22","v":0},{"$f":"Contemporary!S22","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A24","v":"E-401"},{"$f":"Contemporary!U24","v":0},{"$f":"Contemporary!S24","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A25","v":"E-402"},{"$f":"Contemporary!U25","v":0},{"$f":"Contemporary!S25","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A26","v":"E-403"},{"$f":"Contemporary!U26","v":0},{"$f":"Contemporary!S26","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A27","v":"E-404"},{"$f":"Contemporary!U27","v":0},{"$f":"Contemporary!S27","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A29","v":"F-401"},{"$f":"Contemporary!U29","v":0},{"$f":"Contemporary!S29","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A30","v":"F-402"},{"$f":"Contemporary!U30","v":0},{"$f":"Contemporary!S30","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A31","v":"F-403"},{"$f":"Contemporary!U31","v":0},{"$f":"Contemporary!S31","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A32","v":"F-404"},{"$f":"Contemporary!U32","v":0},{"$f":"Contemporary!S32","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A34","v":"G-401"},{"$f":"Contemporary!U34","v":0},{"$f":"Contemporary!S34","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A35","v":"G-402"},{"$f":"Contemporary!U35","v":0},{"$f":"Contemporary!S35","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A36","v":"G-403"},{"$f":"Contemporary!U36","v":0},{"$f":"Contemporary!S36","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A37","v":"G-404"},{"$f":"Contemporary!U37","v":0},{"$f":"Contemporary!S37","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A39","v":"H-401"},{"$f":"Contemporary!U39","v":0},{"$f":"Contemporary!S39","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A40","v":"H-402"},{"$f":"Contemporary!U40","v":0},{"$f":"Contemporary!S40","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A41","v":"H-403"},{"$f":"Contemporary!U41","v":0},{"$f":"Contemporary!S41","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A42","v":"H-404"},{"$f":"Contemporary!U42","v":0},{"$f":"Contemporary!S42","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A44","v":"J-401"},{"$f":"Contemporary!U44","v":0},{"$f":"Contemporary!S44","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A45","v":"J-402"},{"$f":"Contemporary!U45","v":0},{"$f":"Contemporary!S45","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A46","v":"J-403"},{"$f":"Contemporary!U46","v":0},{"$f":"Contemporary!S46","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Contemporary!A47","v":"J-404"},{"$f":"Contemporary!U47","v":0},{"$f":"Contemporary!S47","v":0},{"$f":"IF((Table7101213[[#This Row],[Rank]]+Table7101213[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]

{"sheet":"Pantomime","index":9,"n_rows":47,"n_cols":30,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Pantomimes",null,null,null,null,null,null,null,null,null,"Rank 1-4",null,null,null,null,null,null,null,null,null,null,null,null,"S","E","G","F","1violation","2violations","3violations"]
[null,null,null,null,null,null,null,null,null,null,"Round 1:",null,"Round 2:",null,"Round 3:",null,"-2 for each"]
[null,null,null,null,null,"Student Name",null,"Student Name",null,"Title of Piece","R1 rank","R1 score","R2 rank","R2 score","R3 rank","R3 score","Time Violations",null,"TOTAL SCORE",null,"TOTAL RANK",null,null,"TOTAL SCHOOL SWEEPS POINTS"]
["A-501",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q4=\"1violation\",-7*1,IF(Q4=\"2violations\",-7*2,IF(Q4=\"3violations\",-7*3,IF(Q4=\"\",\"\"))))","v":""},{"$f":"SUM(L4,N4,P4,R4)","v":0},null,{"$f":"SUM(K4,M4,O4)","v":0},null,null,null,{"$f":"SUM(S4,S6,S5,S7)","v":0}]
["A-502",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q5=\"1violation\",-7*1,IF(Q5=\"2violations\",-7*2,IF(Q5=\"3violations\",-7*3,IF(Q5=\"\",\"\"))))","v":""},{"$f":"SUM(L5,N5,P5,R5)","v":0},null,{"$f":"SUM(K5,M5,O5)","v":0}]
["A-503",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L6,N6,P6,R6)","v":0},null,{"$f":"SUM(K6,M6,O6)","v":0}]
["A-504",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L7,N7,P7,R7)","v":0},null,{"$f":"SUM(K7,M7,O7)","v":0}]
[]
["B-501",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L9,N9,P9,R9)","v":0},null,{"$f":"SUM(K9,M9,O9)","v":0},null,null,null,{"$f":"SUM(S9,S11,S10,S12)","v":0}]
["B-502",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L10,N10,P10,R10)","v":0},null,{"$f":"SUM(K10,M10,O10)","v":0}]
["B-503",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L11,N11,P11,R11)","v":0},null,{"$f":"SUM(K11,M11,O11)","v":0}]
["B-504",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L12,N12,P12,R12)","v":0},null,{"$f":"SUM(K12,M12,O12)","v":0}]
[]
["C-501",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L14,N14,P14,R14)","v":0},null,{"$f":"SUM(K14,M14,O14)","v":0},null,null,null,{"$f":"SUM(S14,S16,S15,S17)","v":0}]
["C-502",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L15,N15,P15,R15)","v":0},null,{"$f":"SUM(K15,M15,O15)","v":0}]
["C-503",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L16,N16,P16,R16)","v":0},null,{"$f":"SUM(K16,M16,O16)","v":0}]
["C-504",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L17,N17,P17,R17)","v":0},null,{"$f":"SUM(K17,M17,O17)","v":0}]
[]
["D-501",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L19,N19,P19,R19)","v":0},null,{"$f":"SUM(K19,M19,O19)","v":0},null,null,null,{"$f":"SUM(S19,S21,S20,S22)","v":0}]
["D-502",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L20,N20,P20,R20)","v":0},null,{"$f":"SUM(K20,M20,O20)","v":0}]
["D-503",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L21,N21,P21,R21)","v":0},null,{"$f":"SUM(K21,M21,O21)","v":0}]
["D-504",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L22,N22,P22,R22)","v":0},null,{"$f":"SUM(K22,M22,O22)","v":0}]
[]
["E-501",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L24,N24,P24,R24)","v":0},null,{"$f":"SUM(K24,M24,O24)","v":0},null,null,null,{"$f":"SUM(S24,S26,S25,S27)","v":0}]
["E-502",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L25,N25,P25,R25)","v":0},null,{"$f":"SUM(K25,M25,O25)","v":0}]
["E-503",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L26,N26,P26,R26)","v":0},null,{"$f":"SUM(K26,M26,O26)","v":0}]
["E-504",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L27,N27,P27,R27)","v":0},null,{"$f":"SUM(K27,M27,O27)","v":0}]
[]
["F-501",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L29,N29,P29,R29)","v":0},null,{"$f":"SUM(K29,M29,O29)","v":0},null,null,null,{"$f":"SUM(S29,S31,S30,S32)","v":0}]
["F-502",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L30,N30,P30,R30)","v":0},null,{"$f":"SUM(K30,M30,O30)","v":0}]
["F-503",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L31,N31,P31,R31)","v":0},null,{"$f":"SUM(K31,M31,O31)","v":0}]
["F-504",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L32,N32,P32,R32)","v":0},null,{"$f":"SUM(K32,M32,O32)","v":0}]
[]
["G-501",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L34,N34,P34,R34)","v":0},null,{"$f":"SUM(K34,M34,O34)","v":0},null,null,null,{"$f":"SUM(S34,S36,S35,S37)","v":0}]
["G-502",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L35,N35,P35,R35)","v":0},null,{"$f":"SUM(K35,M35,O35)","v":0}]
["G-503",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L36,N36,P36,R36)","v":0},null,{"$f":"SUM(K36,M36,O36)","v":0}]
["G-504",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L37,N37,P37,R37)","v":0},null,{"$f":"SUM(K37,M37,O37)","v":0}]
[]
["H-501",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L39,N39,P39,R39)","v":0},null,{"$f":"SUM(K39,M39,O39)","v":0},null,null,null,{"$f":"SUM(S39,S41,S40,S42)","v":0}]
["H-502",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L40,N40,P40,R40)","v":0},null,{"$f":"SUM(K40,M40,O40)","v":0}]
["H-503",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L41,N41,P41,R41)","v":0},null,{"$f":"SUM(K41,M41,O41)","v":0}]
["H-504",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L42,N42,P42,R42)","v":0},null,{"$f":"SUM(K42,M42,O42)","v":0}]
[]
["J-501",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L44,N44,P44,R44)","v":0},null,{"$f":"SUM(K44,M44,O44)","v":0},null,null,null,{"$f":"SUM(S44,S46,S45,S47)","v":0}]
["J-502",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L45,N45,P45,R45)","v":0},null,{"$f":"SUM(K45,M45,O45)","v":0}]
["J-503",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L46,N46,P46,R46)","v":0},null,{"$f":"SUM(K46,M46,O46)","v":0}]
["J-504",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L47,N47,P47,R47)","v":0},null,{"$f":"SUM(K47,M47,O47)","v":0}]

{"sheet":"PantomimeMR","index":10,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Pantomime",null,null,null,"Finals Medals Round Scores"]
["ID","Rank","Score","LeaveBlank","MR 1 Rank","MR 1 Score","MR2 Rank","MR 2 Score","MR3 Rank","MR 3 Score","Total MR Rank","Total MR Score"]
[{"$f":"Pantomime!A4","v":"A-501"},{"$f":"Pantomime!U4","v":0},{"$f":"Pantomime!S4","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,{"$f":"SUM(E3,G3,I3)","v":0},{"$f":"SUM(F3,H3,J3)","v":0}]
[{"$f":"Pantomime!A5","v":"A-502"},{"$f":"Pantomime!U5","v":0},{"$f":"Pantomime!S5","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A6","v":"A-503"},{"$f":"Pantomime!U6","v":0},{"$f":"Pantomime!S6","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A7","v":"A-504"},{"$f":"Pantomime!U7","v":0},{"$f":"Pantomime!S7","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A9","v":"B-501"},{"$f":"Pantomime!U9","v":0},{"$f":"Pantomime!S9","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A10","v":"B-502"},{"$f":"Pantomime!U10","v":0},{"$f":"Pantomime!S10","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A11","v":"B-503"},{"$f":"Pantomime!U11","v":0},{"$f":"Pantomime!S11","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A12","v":"B-504"},{"$f":"Pantomime!U12","v":0},{"$f":"Pantomime!S12","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A14","v":"C-501"},{"$f":"Pantomime!U14","v":0},{"$f":"Pantomime!S14","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A15","v":"C-502"},{"$f":"Pantomime!U15","v":0},{"$f":"Pantomime!S15","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A16","v":"C-503"},{"$f":"Pantomime!U16","v":0},{"$f":"Pantomime!S16","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A17","v":"C-504"},{"$f":"Pantomime!U17","v":0},{"$f":"Pantomime!S17","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A19","v":"D-501"},{"$f":"Pantomime!U19","v":0},{"$f":"Pantomime!S19","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A20","v":"D-502"},{"$f":"Pantomime!U20","v":0},{"$f":"Pantomime!S20","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A21","v":"D-503"},{"$f":"Pantomime!U21","v":0},{"$f":"Pantomime!S21","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A22","v":"D-504"},{"$f":"Pantomime!U22","v":0},{"$f":"Pantomime!S22","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A24","v":"E-501"},{"$f":"Pantomime!U24","v":0},{"$f":"Pantomime!S24","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A25","v":"E-502"},{"$f":"Pantomime!U25","v":0},{"$f":"Pantomime!S25","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A26","v":"E-503"},{"$f":"Pantomime!U26","v":0},{"$f":"Pantomime!S26","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A27","v":"E-504"},{"$f":"Pantomime!U27","v":0},{"$f":"Pantomime!S27","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A29","v":"F-501"},{"$f":"Pantomime!U29","v":0},{"$f":"Pantomime!S29","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A30","v":"F-502"},{"$f":"Pantomime!U30","v":0},{"$f":"Pantomime!S30","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A31","v":"F-503"},{"$f":"Pantomime!U31","v":0},{"$f":"Pantomime!S31","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A32","v":"F-504"},{"$f":"Pantomime!U32","v":0},{"$f":"Pantomime!S32","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A34","v":"G-501"},{"$f":"Pantomime!U34","v":0},{"$f":"Pantomime!S34","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A35","v":"G-502"},{"$f":"Pantomime!U35","v":0},{"$f":"Pantomime!S35","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A36","v":"G-503"},{"$f":"Pantomime!U36","v":0},{"$f":"Pantomime!S36","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A37","v":"G-504"},{"$f":"Pantomime!U37","v":0},{"$f":"Pantomime!S37","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A39","v":"H-501"},{"$f":"Pantomime!U39","v":0},{"$f":"Pantomime!S39","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A40","v":"H-502"},{"$f":"Pantomime!U40","v":0},{"$f":"Pantomime!S40","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A41","v":"H-503"},{"$f":"Pantomime!U41","v":0},{"$f":"Pantomime!S41","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A42","v":"H-504"},{"$f":"Pantomime!U42","v":0},{"$f":"Pantomime!S42","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A44","v":"J-501"},{"$f":"Pantomime!U44","v":0},{"$f":"Pantomime!S44","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A45","v":"J-502"},{"$f":"Pantomime!U45","v":0},{"$f":"Pantomime!S45","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A46","v":"J-503"},{"$f":"Pantomime!U46","v":0},{"$f":"Pantomime!S46","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"Pantomime!A47","v":"J-504"},{"$f":"Pantomime!U47","v":0},{"$f":"Pantomime!S47","v":0},{"$f":"IF((Table710121314[[#This Row],[Rank]]+Table710121314[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]

{"sheet":"MusicalTheatre","index":11,"n_rows":47,"n_cols":30,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Musical Theatre",null,null,null,null,null,null,null,null,null,"Rank 1-4",null,null,null,null,null,null,null,null,null,null,null,null,"S","E","G","F","1violation","2violations","3violations"]
[null,null,null,null,null,null,null,null,null,null,"Round 1:",null,"Round 2:",null,"Round 3:",null,"-2 for each"]
[null,"Student Name",null,"Student Name",null,"Student Name",null,"Student Name",null,"Title of Piece","R1 rank","R1 score","R2 rank","R2 score","R3 rank","R3 score","Time Violations",null,"TOTAL SCORE",null,"TOTAL RANK",null,null,"TOTAL SCHOOL SWEEPS POINTS"]
["A-601",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q4=\"1violation\",-7*1,IF(Q4=\"2violations\",-7*2,IF(Q4=\"3violations\",-7*3,IF(Q4=\"\",\"\"))))","v":""},{"$f":"SUM(L4,N4,P4,R4)","v":0},null,{"$f":"SUM(K4,M4,O4)","v":0},null,null,null,{"$f":"SUM(S4,S6,S5,S7)","v":0}]
["A-602",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q5=\"1violation\",-7*1,IF(Q5=\"2violations\",-7*2,IF(Q5=\"3violations\",-7*3,IF(Q5=\"\",\"\"))))","v":""},{"$f":"SUM(L5,N5,P5,R5)","v":0},null,{"$f":"SUM(K5,M5,O5)","v":0}]
["A-603",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L6,N6,P6,R6)","v":0},null,{"$f":"SUM(K6,M6,O6)","v":0}]
["A-604",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L7,N7,P7,R7)","v":0},null,{"$f":"SUM(K7,M7,O7)","v":0}]
[]
["B-601",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L9,N9,P9,R9)","v":0},null,{"$f":"SUM(K9,M9,O9)","v":0},null,null,null,{"$f":"SUM(S9,S11,S10,S12)","v":0}]
["B-602",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L10,N10,P10,R10)","v":0},null,{"$f":"SUM(K10,M10,O10)","v":0}]
["B-603",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L11,N11,P11,R11)","v":0},null,{"$f":"SUM(K11,M11,O11)","v":0}]
["B-604",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L12,N12,P12,R12)","v":0},null,{"$f":"SUM(K12,M12,O12)","v":0}]
[]
["C-601",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L14,N14,P14,R14)","v":0},null,{"$f":"SUM(K14,M14,O14)","v":0},null,null,null,{"$f":"SUM(S14,S16,S15,S17)","v":0}]
["C-602",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L15,N15,P15,R15)","v":0},null,{"$f":"SUM(K15,M15,O15)","v":0}]
["C-603",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L16,N16,P16,R16)","v":0},null,{"$f":"SUM(K16,M16,O16)","v":0}]
["C-604",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L17,N17,P17,R17)","v":0},null,{"$f":"SUM(K17,M17,O17)","v":0}]
[]
["D-601",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L19,N19,P19,R19)","v":0},null,{"$f":"SUM(K19,M19,O19)","v":0},null,null,null,{"$f":"SUM(S19,S21,S20,S22)","v":0}]
["D-602",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L20,N20,P20,R20)","v":0},null,{"$f":"SUM(K20,M20,O20)","v":0}]
["D-603",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L21,N21,P21,R21)","v":0},null,{"$f":"SUM(K21,M21,O21)","v":0}]
["D-604",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L22,N22,P22,R22)","v":0},null,{"$f":"SUM(K22,M22,O22)","v":0}]
[]
["E-601",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L24,N24,P24,R24)","v":0},null,{"$f":"SUM(K24,M24,O24)","v":0},null,null,null,{"$f":"SUM(S24,S26,S25,S27)","v":0}]
["E-602",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L25,N25,P25,R25)","v":0},null,{"$f":"SUM(K25,M25,O25)","v":0}]
["E-603",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L26,N26,P26,R26)","v":0},null,{"$f":"SUM(K26,M26,O26)","v":0}]
["E-604",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L27,N27,P27,R27)","v":0},null,{"$f":"SUM(K27,M27,O27)","v":0}]
[]
["F-601",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L29,N29,P29,R29)","v":0},null,{"$f":"SUM(K29,M29,O29)","v":0},null,null,null,{"$f":"SUM(S29,S31,S30,S32)","v":0}]
["F-602",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L30,N30,P30,R30)","v":0},null,{"$f":"SUM(K30,M30,O30)","v":0}]
["F-603",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L31,N31,P31,R31)","v":0},null,{"$f":"SUM(K31,M31,O31)","v":0}]
["F-604",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L32,N32,P32,R32)","v":0},null,{"$f":"SUM(K32,M32,O32)","v":0}]
[]
["G-601",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L34,N34,P34,R34)","v":0},null,{"$f":"SUM(K34,M34,O34)","v":0},null,null,null,{"$f":"SUM(S34,S36,S35,S37)","v":0}]
["G-602",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L35,N35,P35,R35)","v":0},null,{"$f":"SUM(K35,M35,O35)","v":0}]
["G-603",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L36,N36,P36,R36)","v":0},null,{"$f":"SUM(K36,M36,O36)","v":0}]
["G-604",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L37,N37,P37,R37)","v":0},null,{"$f":"SUM(K37,M37,O37)","v":0}]
[]
["H-601",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L39,N39,P39,R39)","v":0},null,{"$f":"SUM(K39,M39,O39)","v":0},null,null,null,{"$f":"SUM(S39,S41,S40,S42)","v":0}]
["H-602",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L40,N40,P40,R40)","v":0},null,{"$f":"SUM(K40,M40,O40)","v":0}]
["H-603",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L41,N41,P41,R41)","v":0},null,{"$f":"SUM(K41,M41,O41)","v":0}]
["H-604",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L42,N42,P42,R42)","v":0},null,{"$f":"SUM(K42,M42,O42)","v":0}]
[]
["J-601",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L44,N44,P44,R44)","v":0},null,{"$f":"SUM(K44,M44,O44)","v":0},null,null,null,{"$f":"SUM(S44,S46,S45,S47)","v":0}]
["J-602",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L45,N45,P45,R45)","v":0},null,{"$f":"SUM(K45,M45,O45)","v":0}]
["J-603",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L46,N46,P46,R46)","v":0},null,{"$f":"SUM(K46,M46,O46)","v":0}]
["J-604",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUM(L47,N47,P47,R47)","v":0},null,{"$f":"SUM(K47,M47,O47)","v":0}]

{"sheet":"MusicalTheatreMR","index":12,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Musical Theatre",null,null,null,"Finals Medals Round Scores"]
["ID","Rank","Score","LeaveBlank","MR 1 Rank","MR 1 Score","MR2 Rank","MR 2 Score","MR3 Rank","MR 3 Score","Total MR Rank","Total MR Score"]
[{"$f":"MusicalTheatre!A4","v":"A-601"},{"$f":"MusicalTheatre!U4","v":0},{"$f":"MusicalTheatre!S4","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,{"$f":"SUM(E3,G3,I3)","v":0},{"$f":"SUM(F3,H3,J3)","v":0}]
[{"$f":"MusicalTheatre!A5","v":"A-602"},{"$f":"MusicalTheatre!U5","v":0},{"$f":"MusicalTheatre!S5","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A6","v":"A-603"},{"$f":"MusicalTheatre!U6","v":0},{"$f":"MusicalTheatre!S6","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A7","v":"A-604"},{"$f":"MusicalTheatre!U7","v":0},{"$f":"MusicalTheatre!S7","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A9","v":"B-601"},{"$f":"MusicalTheatre!U9","v":0},{"$f":"MusicalTheatre!S9","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A10","v":"B-602"},{"$f":"MusicalTheatre!U10","v":0},{"$f":"MusicalTheatre!S10","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A11","v":"B-603"},{"$f":"MusicalTheatre!U11","v":0},{"$f":"MusicalTheatre!S11","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A12","v":"B-604"},{"$f":"MusicalTheatre!U12","v":0},{"$f":"MusicalTheatre!S12","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A14","v":"C-601"},{"$f":"MusicalTheatre!U14","v":0},{"$f":"MusicalTheatre!S14","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A15","v":"C-602"},{"$f":"MusicalTheatre!U15","v":0},{"$f":"MusicalTheatre!S15","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A16","v":"C-603"},{"$f":"MusicalTheatre!U16","v":0},{"$f":"MusicalTheatre!S16","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A17","v":"C-604"},{"$f":"MusicalTheatre!U17","v":0},{"$f":"MusicalTheatre!S17","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A19","v":"D-601"},{"$f":"MusicalTheatre!U19","v":0},{"$f":"MusicalTheatre!S19","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A20","v":"D-602"},{"$f":"MusicalTheatre!U20","v":0},{"$f":"MusicalTheatre!S20","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A21","v":"D-603"},{"$f":"MusicalTheatre!U21","v":0},{"$f":"MusicalTheatre!S21","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A22","v":"D-604"},{"$f":"MusicalTheatre!U22","v":0},{"$f":"MusicalTheatre!S22","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A24","v":"E-601"},{"$f":"MusicalTheatre!U24","v":0},{"$f":"MusicalTheatre!S24","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A25","v":"E-602"},{"$f":"MusicalTheatre!U25","v":0},{"$f":"MusicalTheatre!S25","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A26","v":"E-603"},{"$f":"MusicalTheatre!U26","v":0},{"$f":"MusicalTheatre!S26","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A27","v":"E-604"},{"$f":"MusicalTheatre!U27","v":0},{"$f":"MusicalTheatre!S27","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A29","v":"F-601"},{"$f":"MusicalTheatre!U29","v":0},{"$f":"MusicalTheatre!S29","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A30","v":"F-602"},{"$f":"MusicalTheatre!U30","v":0},{"$f":"MusicalTheatre!S30","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A31","v":"F-603"},{"$f":"MusicalTheatre!U31","v":0},{"$f":"MusicalTheatre!S31","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A32","v":"F-604"},{"$f":"MusicalTheatre!U32","v":0},{"$f":"MusicalTheatre!S32","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A34","v":"G-601"},{"$f":"MusicalTheatre!U34","v":0},{"$f":"MusicalTheatre!S34","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A35","v":"G-602"},{"$f":"MusicalTheatre!U35","v":0},{"$f":"MusicalTheatre!S35","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A36","v":"G-603"},{"$f":"MusicalTheatre!U36","v":0},{"$f":"MusicalTheatre!S36","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A37","v":"G-604"},{"$f":"MusicalTheatre!U37","v":0},{"$f":"MusicalTheatre!S37","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A39","v":"H-601"},{"$f":"MusicalTheatre!U39","v":0},{"$f":"MusicalTheatre!S39","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A40","v":"H-602"},{"$f":"MusicalTheatre!U40","v":0},{"$f":"MusicalTheatre!S40","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A41","v":"H-603"},{"$f":"MusicalTheatre!U41","v":0},{"$f":"MusicalTheatre!S41","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A42","v":"H-604"},{"$f":"MusicalTheatre!U42","v":0},{"$f":"MusicalTheatre!S42","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A44","v":"J-601"},{"$f":"MusicalTheatre!U44","v":0},{"$f":"MusicalTheatre!S44","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A45","v":"J-602"},{"$f":"MusicalTheatre!U45","v":0},{"$f":"MusicalTheatre!S45","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A46","v":"J-603"},{"$f":"MusicalTheatre!U46","v":0},{"$f":"MusicalTheatre!S46","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]
[{"$f":"MusicalTheatre!A47","v":"J-604"},{"$f":"MusicalTheatre!U47","v":0},{"$f":"MusicalTheatre!S47","v":0},{"$f":"IF((Table71012131415[[#This Row],[Rank]]+Table71012131415[[#This Row],[Score]])>0,1,0)","v":0},null,null,null,null,null,null,0,0]

{"sheet":"One-Acts","index":13,"n_rows":20,"n_cols":35,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["ONE-ACTS",null,null,null,null,null,null,null,null,null,"Rank 1-6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S","E","G","F",null,"1violation"]
[null,null,null,null,null,null,null,null,null,null,"Judge 1",null,"Judge 2",null,"Judge 3"]
[null,"Title of Piece",null,null,null,null,null,null,null,"Title of Piece","J1 rank","J1 score","J2 rank","J2 score","J3 rank","J3 score",null,null,"TOTAL RANK",null,"TOTAL SCORE",null,"TOTAL SCHOOL SWEEPS POINTS",null,null,"Time Violations"]
["A-701",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K4,M4,O4)","v":0},null,{"$f":"SUM(L4,N4,P4)","v":0},null,{"$f":"SUM(U4,AA4)","v":0},null,null,null,{"$f":"IF(Z4=\"1violation\",-35*1,IF(Z4=\"2violations\",-35*2,IF(Z4=\"3violations\",-35*3,IF(Z4=\"\",\"\"))))","v":""}]
[]
["B-701",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K6,M6,O6)","v":0},null,{"$f":"SUM(L6,N6,P6)","v":0},null,0,null,null,null,{"$f":"IF(Z6=\"1violation\",-10*1,IF(Z6=\"2violations\",-10*2,IF(Z6=\"3violations\",-10*3,IF(Z6=\"\",\"\"))))","v":""}]
[]
["C-701",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K8,M8,O8)","v":0},null,{"$f":"SUM(L8,N8,P8)","v":0},null,0,null,null,null,""]
[]
["D-701",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,null,null,""]
[]
["E-701",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,null,null,""]
[]
["F-701",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,null,null,""]
[]
["G-701",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,null,null,""]
[]
["H-701",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,null,null,""]
[]
["J-701",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,0,null,null,null,""]

{"sheet":"CostumeDesign","index":14,"n_rows":47,"n_cols":31,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Costume Design",null,null,null,null,null,null,null,null,null,"Rank 1-6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1violation","2violations","3violations"]
[null,null,null,null,null,null,null,null,null,null,"Round 1:",null,"Round 2:",null,"Round 3:"]
[null,null,null,null,null,null,null,"Student Name",null,"Title of Play","R1 rank","R1 score","R2 rank","R2 score","R3 rank","R3 score",null,null,"TOTAL SCORE",null,"TOTAL RANK"]
["A-801",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L4,N4,P4)","v":0},null,{"$f":"SUM(K4,M4,O4)","v":0}]
["A-802",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["A-803",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["A-804",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[]
["B-801",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["B-802",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["B-803",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["B-804",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[]
["C-801",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["C-802",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["C-803",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["C-804",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[]
["D-801",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["D-802",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["D-803",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["D-804",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[]
["E-801",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["E-802",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["E-803",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["E-804",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[]
["F-801",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["F-802",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["F-803",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["F-804",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[]
["G-801",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["G-802",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["G-803",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["G-804",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[]
["H-801",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["H-802",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["H-803",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["H-804",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
[]
["J-801",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L44,N44,P44)","v":0},null,{"$f":"SUM(K44,M44,O44)","v":0}]
["J-802",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["J-803",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["J-804",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0]

{"sheet":"ScenicDesign","index":15,"n_rows":47,"n_cols":31,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Scenic Design",null,null,null,null,null,null,null,null,null,"Rank 1-6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1violation","2violations","3violations"]
[null,null,null,null,null,null,null,null,null,null,"Round 1:",null,"Round 2:",null,"Round 3:"]
[null,null,null,null,null,null,null,"Student Name",null,"Title of Play","R1 rank","R1 score","R2 rank","R2 score","R3 rank","R3 score",null,null,"TOTAL SCORE",null,"TOTAL RANK"]
["A-901",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L4,N4,P4)","v":0},null,{"$f":"SUM(K4,M4,O4)","v":0}]
["A-902",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L5,N5,P5)","v":0},null,{"$f":"SUM(K5,M5,O5)","v":0}]
["A-903",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6,N6,P6)","v":0},null,{"$f":"SUM(K6,M6,O6)","v":0}]
["A-904",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L7,N7,P7)","v":0},null,{"$f":"SUM(K7,M7,O7)","v":0}]
[]
["B-901",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L9,N9,P9)","v":0},null,{"$f":"SUM(K9,M9,O9)","v":0}]
["B-902",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10,N10,P10)","v":0},null,{"$f":"SUM(K10,M10,O10)","v":0}]
["B-903",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L11,N11,P11)","v":0},null,{"$f":"SUM(K11,M11,O11)","v":0}]
["B-904",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L12,N12,P12)","v":0},null,{"$f":"SUM(K12,M12,O12)","v":0}]
[]
["C-901",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L14,N14,P14)","v":0},null,{"$f":"SUM(K14,M14,O14)","v":0}]
["C-902",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L15,N15,P15)","v":0},null,{"$f":"SUM(K15,M15,O15)","v":0}]
["C-903",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L16,N16,P16)","v":0},null,{"$f":"SUM(K16,M16,O16)","v":0}]
["C-904",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L17,N17,P17)","v":0},null,{"$f":"SUM(K17,M17,O17)","v":0}]
[]
["D-901",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L19,N19,P19)","v":0},null,{"$f":"SUM(K19,M19,O19)","v":0}]
["D-902",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L20,N20,P20)","v":0},null,{"$f":"SUM(K20,M20,O20)","v":0}]
["D-903",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L21,N21,P21)","v":0},null,{"$f":"SUM(K21,M21,O21)","v":0}]
["D-904",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L22,N22,P22)","v":0},null,{"$f":"SUM(K22,M22,O22)","v":0}]
[]
["E-901",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L24,N24,P24)","v":0},null,{"$f":"SUM(K24,M24,O24)","v":0}]
["E-902",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L25,N25,P25)","v":0},null,{"$f":"SUM(K25,M25,O25)","v":0}]
["E-903",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L26,N26,P26)","v":0},null,{"$f":"SUM(K26,M26,O26)","v":0}]
["E-904",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L27,N27,P27)","v":0},null,{"$f":"SUM(K27,M27,O27)","v":0}]
[]
["F-901",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L29,N29,P29)","v":0},null,{"$f":"SUM(K29,M29,O29)","v":0}]
["F-902",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L30,N30,P30)","v":0},null,{"$f":"SUM(K30,M30,O30)","v":0}]
["F-903",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L31,N31,P31)","v":0},null,{"$f":"SUM(K31,M31,O31)","v":0}]
["F-904",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L32,N32,P32)","v":0},null,{"$f":"SUM(K32,M32,O32)","v":0}]
[]
["G-901",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L34,N34,P34)","v":0},null,{"$f":"SUM(K34,M34,O34)","v":0}]
["G-902",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L35,N35,P35)","v":0},null,{"$f":"SUM(K35,M35,O35)","v":0}]
["G-903",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L36,N36,P36)","v":0},null,{"$f":"SUM(K36,M36,O36)","v":0}]
["G-904",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L37,N37,P37)","v":0},null,{"$f":"SUM(K37,M37,O37)","v":0}]
[]
["H-901",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L39,N39,P39)","v":0},null,{"$f":"SUM(K39,M39,O39)","v":0}]
["H-902",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L40,N40,P40)","v":0},null,{"$f":"SUM(K40,M40,O40)","v":0}]
["H-903",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L41,N41,P41)","v":0},null,{"$f":"SUM(K41,M41,O41)","v":0}]
["H-904",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L42,N42,P42)","v":0},null,{"$f":"SUM(K42,M42,O42)","v":0}]
[]
["J-901",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L44,N44,P44)","v":0},null,{"$f":"SUM(K44,M44,O44)","v":0}]
["J-902",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L45,N45,P45)","v":0},null,{"$f":"SUM(K45,M45,O45)","v":0}]
["J-903",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L46,N46,P46)","v":0},null,{"$f":"SUM(K46,M46,O46)","v":0}]
["J-904",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L47,N47,P47)","v":0},null,{"$f":"SUM(K47,M47,O47)","v":0}]

{"sheet":"Sweepstakes","index":16,"n_rows":20,"n_cols":23,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["FINAL SWEEPSTAKES SCORES"]
[]
[null,"School Name",null,"HUMOROUS MONOLOGUES",null,null,"DRAMATIC MONOLOGUES",null,null,"CLASSICAL SCENES",null,null,"CONTEMPORARY SCENES",null,null,"PANTOMIMES",null,"MUSICAL THEATRE",null,null,"ONE-ACT",null,"TOTAL"]
["A",null,null,null,{"$f":"SUM('Humorous Monologues'!Y4)","v":0},null,null,{"$f":"SUM(Dramatic!Y4)","v":0},null,null,{"$f":"SUM(Classical!Y4)","v":0},null,null,{"$f":"SUM(Contemporary!Y4)","v":0},null,{"$f":"SUM(Pantomime!Y4)","v":0},null,{"$f":"SUM(MusicalTheatre!Y4)","v":0},null,null,{"$f":"'One-Acts'!W4","v":0},null,{"$f":"SUM(E4:U4)","v":0}]
[]
["B",null,null,null,{"$f":"SUM('Humorous Monologues'!Y9)","v":0},null,null,{"$f":"SUM(Dramatic!Y9)","v":0},null,null,{"$f":"SUM(Classical!Y9)","v":0},null,null,{"$f":"SUM(Contemporary!Y9)","v":0},null,{"$f":"SUM(Pantomime!Y9)","v":0},null,{"$f":"SUM(MusicalTheatre!Y9)","v":0},null,null,{"$f":"'One-Acts'!W6","v":0},null,0]
[]
["C",null,null,null,{"$f":"SUM('Humorous Monologues'!Y14)","v":0},null,null,{"$f":"SUM(Dramatic!Y14)","v":0},null,null,{"$f":"SUM(Classical!Y14)","v":0},null,null,{"$f":"SUM(Contemporary!Y14)","v":0},null,{"$f":"SUM(Pantomime!Y14)","v":0},null,{"$f":"SUM(MusicalTheatre!Y14)","v":0},null,null,{"$f":"'One-Acts'!W8","v":0},null,0]
[]
["D",null,null,null,{"$f":"SUM('Humorous Monologues'!Y19)","v":0},null,null,{"$f":"SUM(Dramatic!Y19)","v":0},null,null,{"$f":"SUM(Classical!Y19)","v":0},null,null,{"$f":"SUM(Contemporary!Y19)","v":0},null,{"$f":"SUM(Pantomime!Y19)","v":0},null,{"$f":"SUM(MusicalTheatre!Y19)","v":0},null,null,{"$f":"'One-Acts'!W10","v":0},null,0]
[]
["E",null,null,null,{"$f":"SUM('Humorous Monologues'!Y24)","v":0},null,null,{"$f":"SUM(Dramatic!Y24)","v":0},null,null,{"$f":"SUM(Classical!Y24)","v":0},null,null,{"$f":"SUM(Contemporary!Y24)","v":0},null,{"$f":"SUM(Pantomime!Y24)","v":0},null,{"$f":"SUM(MusicalTheatre!Y24)","v":0},null,null,{"$f":"'One-Acts'!W12","v":0},null,0]
[]
["F",null,null,null,{"$f":"SUM('Humorous Monologues'!Y29)","v":0},null,null,{"$f":"SUM(Dramatic!Y29)","v":0},null,null,{"$f":"SUM(Classical!Y29)","v":0},null,null,{"$f":"SUM(Contemporary!Y29)","v":0},null,{"$f":"SUM(Pantomime!Y29)","v":0},null,{"$f":"SUM(MusicalTheatre!Y29)","v":0},null,null,{"$f":"'One-Acts'!W14","v":0},null,0]
[]
["G",null,null,null,{"$f":"SUM('Humorous Monologues'!Y34)","v":0},null,null,{"$f":"SUM(Dramatic!Y34)","v":0},null,null,{"$f":"SUM(Classical!Y34)","v":0},null,null,{"$f":"SUM(Contemporary!Y34)","v":0},null,{"$f":"SUM(Pantomime!Y34)","v":0},null,{"$f":"SUM(MusicalTheatre!Y34)","v":0},null,null,{"$f":"'One-Acts'!W16","v":0},null,0]
[]
["H",null,null,null,{"$f":"SUM('Humorous Monologues'!Y39)","v":0},null,null,{"$f":"SUM(Dramatic!Y39)","v":0},null,null,{"$f":"SUM(Classical!Y39)","v":0},null,null,{"$f":"SUM(Contemporary!Y39)","v":0},null,{"$f":"SUM(Pantomime!Y39)","v":0},null,{"$f":"SUM(MusicalTheatre!Y39)","v":0},null,null,{"$f":"'One-Acts'!W18","v":0},null,0]
[]
["J",null,null,null,{"$f":"SUM('Humorous Monologues'!Y44)","v":0},null,null,{"$f":"SUM(Dramatic!Y44)","v":0},null,null,{"$f":"SUM(Classical!Y44)","v":0},null,null,{"$f":"SUM(Contemporary!Y44)","v":0},null,{"$f":"SUM(Pantomime!Y44)","v":0},null,{"$f":"SUM(MusicalTheatre!Y44)","v":0},null,null,{"$f":"'One-Acts'!W20","v":0},null,0]

{"sheet":"ScenicResults","index":17,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Scenic Design"]
["ID","Rank","Score","LeaveBlank"]
[{"$f":"ScenicDesign!A9","v":"B-901"},{"$f":"ScenicDesign!U9","v":0},{"$f":"ScenicDesign!S9","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A24","v":"E-901"},{"$f":"ScenicDesign!U24","v":0},{"$f":"ScenicDesign!S24","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A25","v":"E-902"},{"$f":"ScenicDesign!U25","v":0},{"$f":"ScenicDesign!S25","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A4","v":"A-901"},{"$f":"ScenicDesign!U4","v":0},{"$f":"ScenicDesign!S4","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A5","v":"A-902"},{"$f":"ScenicDesign!U5","v":0},{"$f":"ScenicDesign!S5","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A6","v":"A-903"},{"$f":"ScenicDesign!U6","v":0},{"$f":"ScenicDesign!S6","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A7","v":"A-904"},{"$f":"ScenicDesign!U7","v":0},{"$f":"ScenicDesign!S7","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A10","v":"B-902"},{"$f":"ScenicDesign!U10","v":0},{"$f":"ScenicDesign!S10","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A11","v":"B-903"},{"$f":"ScenicDesign!U11","v":0},{"$f":"ScenicDesign!S11","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A12","v":"B-904"},{"$f":"ScenicDesign!U12","v":0},{"$f":"ScenicDesign!S12","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A14","v":"C-901"},{"$f":"ScenicDesign!U14","v":0},{"$f":"ScenicDesign!S14","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A15","v":"C-902"},{"$f":"ScenicDesign!U15","v":0},{"$f":"ScenicDesign!S15","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A16","v":"C-903"},{"$f":"ScenicDesign!U16","v":0},{"$f":"ScenicDesign!S16","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A17","v":"C-904"},{"$f":"ScenicDesign!U17","v":0},{"$f":"ScenicDesign!S17","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A19","v":"D-901"},{"$f":"ScenicDesign!U19","v":0},{"$f":"ScenicDesign!S19","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A20","v":"D-902"},{"$f":"ScenicDesign!U20","v":0},{"$f":"ScenicDesign!S20","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A21","v":"D-903"},{"$f":"ScenicDesign!U21","v":0},{"$f":"ScenicDesign!S21","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A22","v":"D-904"},{"$f":"ScenicDesign!U22","v":0},{"$f":"ScenicDesign!S22","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A26","v":"E-903"},{"$f":"ScenicDesign!U26","v":0},{"$f":"ScenicDesign!S26","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A27","v":"E-904"},{"$f":"ScenicDesign!U27","v":0},{"$f":"ScenicDesign!S27","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A29","v":"F-901"},{"$f":"ScenicDesign!U29","v":0},{"$f":"ScenicDesign!S29","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A30","v":"F-902"},{"$f":"ScenicDesign!U30","v":0},{"$f":"ScenicDesign!S30","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A31","v":"F-903"},{"$f":"ScenicDesign!U31","v":0},{"$f":"ScenicDesign!S31","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A32","v":"F-904"},{"$f":"ScenicDesign!U32","v":0},{"$f":"ScenicDesign!S32","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A34","v":"G-901"},{"$f":"ScenicDesign!U34","v":0},{"$f":"ScenicDesign!S34","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A35","v":"G-902"},{"$f":"ScenicDesign!U35","v":0},{"$f":"ScenicDesign!S35","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A36","v":"G-903"},{"$f":"ScenicDesign!U36","v":0},{"$f":"ScenicDesign!S36","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A37","v":"G-904"},{"$f":"ScenicDesign!U37","v":0},{"$f":"ScenicDesign!S37","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A39","v":"H-901"},{"$f":"ScenicDesign!U39","v":0},{"$f":"ScenicDesign!S39","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A40","v":"H-902"},{"$f":"ScenicDesign!U40","v":0},{"$f":"ScenicDesign!S40","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A41","v":"H-903"},{"$f":"ScenicDesign!U41","v":0},{"$f":"ScenicDesign!S41","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A42","v":"H-904"},{"$f":"ScenicDesign!U42","v":0},{"$f":"ScenicDesign!S42","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A44","v":"J-901"},{"$f":"ScenicDesign!U44","v":0},{"$f":"ScenicDesign!S44","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A45","v":"J-902"},{"$f":"ScenicDesign!U45","v":0},{"$f":"ScenicDesign!S45","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A46","v":"J-903"},{"$f":"ScenicDesign!U46","v":0},{"$f":"ScenicDesign!S46","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"ScenicDesign!A47","v":"J-904"},{"$f":"ScenicDesign!U47","v":0},{"$f":"ScenicDesign!S47","v":0},{"$f":"IF((Table710121314152[[#This Row],[Rank]]+Table710121314152[[#This Row],[Score]])>0,1,0)","v":0}]

{"sheet":"CostumeResults","index":18,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Costume Design"]
["ID","Rank","Score","LeaveBlank"]
[{"$f":"CostumeDesign!A5","v":"A-802"},{"$f":"CostumeDesign!U5","v":0},{"$f":"CostumeDesign!S5","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A11","v":"B-803"},{"$f":"CostumeDesign!U11","v":0},{"$f":"CostumeDesign!S11","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A4","v":"A-801"},{"$f":"CostumeDesign!U4","v":0},{"$f":"CostumeDesign!S4","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A6","v":"A-803"},{"$f":"CostumeDesign!U6","v":0},{"$f":"CostumeDesign!S6","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A7","v":"A-804"},{"$f":"CostumeDesign!U7","v":0},{"$f":"CostumeDesign!S7","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A9","v":"B-801"},{"$f":"CostumeDesign!U9","v":0},{"$f":"CostumeDesign!S9","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A10","v":"B-802"},{"$f":"CostumeDesign!U10","v":0},{"$f":"CostumeDesign!S10","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A12","v":"B-804"},{"$f":"CostumeDesign!U12","v":0},{"$f":"CostumeDesign!S12","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A14","v":"C-801"},{"$f":"CostumeDesign!U14","v":0},{"$f":"CostumeDesign!S14","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A15","v":"C-802"},{"$f":"CostumeDesign!U15","v":0},{"$f":"CostumeDesign!S15","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A16","v":"C-803"},{"$f":"CostumeDesign!U16","v":0},{"$f":"CostumeDesign!S16","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A17","v":"C-804"},{"$f":"CostumeDesign!U17","v":0},{"$f":"CostumeDesign!S17","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A19","v":"D-801"},{"$f":"CostumeDesign!U19","v":0},{"$f":"CostumeDesign!S19","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A20","v":"D-802"},{"$f":"CostumeDesign!U20","v":0},{"$f":"CostumeDesign!S20","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A21","v":"D-803"},{"$f":"CostumeDesign!U21","v":0},{"$f":"CostumeDesign!S21","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A22","v":"D-804"},{"$f":"CostumeDesign!U22","v":0},{"$f":"CostumeDesign!S22","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A24","v":"E-801"},{"$f":"CostumeDesign!U24","v":0},{"$f":"CostumeDesign!S24","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A25","v":"E-802"},{"$f":"CostumeDesign!U25","v":0},{"$f":"CostumeDesign!S25","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A26","v":"E-803"},{"$f":"CostumeDesign!U26","v":0},{"$f":"CostumeDesign!S26","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A27","v":"E-804"},{"$f":"CostumeDesign!U27","v":0},{"$f":"CostumeDesign!S27","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A29","v":"F-801"},{"$f":"CostumeDesign!U29","v":0},{"$f":"CostumeDesign!S29","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A30","v":"F-802"},{"$f":"CostumeDesign!U30","v":0},{"$f":"CostumeDesign!S30","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A31","v":"F-803"},{"$f":"CostumeDesign!U31","v":0},{"$f":"CostumeDesign!S31","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A32","v":"F-804"},{"$f":"CostumeDesign!U32","v":0},{"$f":"CostumeDesign!S32","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A34","v":"G-801"},{"$f":"CostumeDesign!U34","v":0},{"$f":"CostumeDesign!S34","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A35","v":"G-802"},{"$f":"CostumeDesign!U35","v":0},{"$f":"CostumeDesign!S35","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A36","v":"G-803"},{"$f":"CostumeDesign!U36","v":0},{"$f":"CostumeDesign!S36","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A37","v":"G-804"},{"$f":"CostumeDesign!U37","v":0},{"$f":"CostumeDesign!S37","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A39","v":"H-801"},{"$f":"CostumeDesign!U39","v":0},{"$f":"CostumeDesign!S39","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A40","v":"H-802"},{"$f":"CostumeDesign!U40","v":0},{"$f":"CostumeDesign!S40","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A41","v":"H-803"},{"$f":"CostumeDesign!U41","v":0},{"$f":"CostumeDesign!S41","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A42","v":"H-804"},{"$f":"CostumeDesign!U42","v":0},{"$f":"CostumeDesign!S42","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A44","v":"J-801"},{"$f":"CostumeDesign!U44","v":0},{"$f":"CostumeDesign!S44","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A45","v":"J-802"},{"$f":"CostumeDesign!U45","v":0},{"$f":"CostumeDesign!S45","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A46","v":"J-803"},{"$f":"CostumeDesign!U46","v":0},{"$f":"CostumeDesign!S46","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]
[{"$f":"CostumeDesign!A47","v":"J-804"},{"$f":"CostumeDesign!U47","v":0},{"$f":"CostumeDesign!S47","v":0},{"$f":"IF((Table71012131415235[[#This Row],[Rank]]+Table71012131415235[[#This Row],[Score]])>0,1,0)","v":0}]